UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HXRIo464QFNCoGXSSc0PByTHHvWSAixPkvkt185WxSg='
WHERE
key_id = '8bd9dfcc4230302cbff4f8a2de1a31e4a6129c331afd37d1cbc1b8da200858ba'
AND (
token = 'HXRIo464QFNCoGXSSc0PByTHHvWSAixPkvkt185WxSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)