UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3bgL1i8o6I4SQGm0Bpgpmoj8J7sEsJBZmSTyALVIuPU='
WHERE
key_id = '9f2587990592108a7d25282128bb821a42daf374936b4468b425b12bb09f61cd'
AND (
token = '3bgL1i8o6I4SQGm0Bpgpmoj8J7sEsJBZmSTyALVIuPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)