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