UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7aSBkGph48BI1xn3Ej3BTkG7ImL7+MvSTsXW5WhMPsY='
WHERE
key_id = '653c8b8fb6293b24481bf61e874e34012cdce90404a8ad67d5dec84dd806d25c'
AND (
token = '7aSBkGph48BI1xn3Ej3BTkG7ImL7+MvSTsXW5WhMPsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)