UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T8tJG1wU9PKUmZRsmLW12rHl79dpy8tNzq2Q/t6/D9M='
WHERE
key_id = 'aa656fc98524d7110568bfbb989011e263b80f875bf75b3168febc3beb97f895'
AND (
token = 'T8tJG1wU9PKUmZRsmLW12rHl79dpy8tNzq2Q/t6/D9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)