UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tg/UUVt67FuOob0i8h9HINPShP8DCE6LcDS4Gi8eCLo='
WHERE
key_id = '5f1c5aa0681bcd1bd7dab1dfc865bc3c8f44d86f19af3caae7ff3942a438b1da'
AND (
token = 'Tg/UUVt67FuOob0i8h9HINPShP8DCE6LcDS4Gi8eCLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)