UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0bzckilUgVTRVMsEl85yzy8OIlXvbNYmYURdbOjzPm0='
WHERE
key_id = 'fda660452100013c667ab5b096880484e63a090dcd2bf4f0e91ec335f9ac1283'
AND (
token = '0bzckilUgVTRVMsEl85yzy8OIlXvbNYmYURdbOjzPm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)