UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'snEH22yduZso+Vh3DkwQOXAv/Rf5psKV9njI8J6gV5Q='
WHERE
key_id = '07384ca514e63e2ac42163c47a2b3dbd89901defcad834e9a8c121f52213222a'
AND (
token = 'snEH22yduZso+Vh3DkwQOXAv/Rf5psKV9njI8J6gV5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)