UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZMbIVhTz5D2PdJLa5yH1lwG+Sbhw0TXMXcpSY2/0qaM='
WHERE
key_id = 'df1ea9637dd4def6344efec9c3845801392e0493af03c46b067ecba8830e2a9f'
AND (
token = 'ZMbIVhTz5D2PdJLa5yH1lwG+Sbhw0TXMXcpSY2/0qaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)