UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NcyqO9JI+xKAp4/TB7Kmb4zUIg9pBlNQNlT/a4S/RbM='
WHERE
key_id = 'bd671d9603d00d6814187032a0010120469a13ec23f2bbed08ff497a73f64f1c'
AND (
token = 'NcyqO9JI+xKAp4/TB7Kmb4zUIg9pBlNQNlT/a4S/RbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)