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