UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'id0sK5guBf8foXy5UBlP/Jsz7VJXb56KhsCkMw5ZIpc='
WHERE
key_id = 'c937198fe737a9d0e8d275ccc7f0a91ebbe8e52b13764c7781e1a108457686b4'
AND (
token = 'id0sK5guBf8foXy5UBlP/Jsz7VJXb56KhsCkMw5ZIpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)