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