UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tbPjhYSNldTUjBjq42WCC0SeTV1NO3Afrz4V6ecTRgg='
WHERE
key_id = '52a6c607cbfc1b0f12786e0bef3d4ea7be9698368bccb5055c178d27b1bc99c7'
AND (
token = 'tbPjhYSNldTUjBjq42WCC0SeTV1NO3Afrz4V6ecTRgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)