UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rItaEQ3FagRRajGK3OKpe3r9wj8t7McaIrYCA6bafpI='
WHERE
key_id = 'c04957c9279bcecd1064617319ddbfe8c8a50f228c07f281f44c43740753b476'
AND (
token = 'rItaEQ3FagRRajGK3OKpe3r9wj8t7McaIrYCA6bafpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)