UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Q1cba+jTj8eoPG12J/0u8DJ9WPyVjEva88Dd+22yw8='
WHERE
key_id = 'b981e06a14c3c9530e5ded788a731d93cf174bb24f339b69e95d668fd624c917'
AND (
token = '3Q1cba+jTj8eoPG12J/0u8DJ9WPyVjEva88Dd+22yw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)