neiyou_user_web/app/Models/VerifyCode.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

/**
 * 注册时的激活验证码
 *
 * @property int $id
 * @property string $address 用户邮箱
 * @property string $code 验证码
 * @property int $status 状态：0-未使用、1-已使用、2-已失效
 * @property \Illuminate\Support\Carbon $created_at 创建时间
 * @property \Illuminate\Support\Carbon $updated_at 最后更新时间
 * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode newQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode query()
 * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode recentUnused()
 * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereAddress($value)
 * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereCode($value)
 * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereStatus($value)
 * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereUpdatedAt($value)
 * @mixin \Eloquent
 */
class VerifyCode extends Model
{
    protected $table = 'verify_code';
    protected $guarded = [];

    public function scopeRecentUnused($query)
    {
        return $query->whereStatus(0)->where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-15 minutes')));
    }
}