UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zl1bq5vSzhIYm+vlO5ZIV4mwniDZkhQVCKARUhxaQfM='
WHERE
key_id = 'e9b1164b32f68d56bc6b7f6df643249b5d361071d91ef5872c48cc949c3878be'
AND (
token = 'Zl1bq5vSzhIYm+vlO5ZIV4mwniDZkhQVCKARUhxaQfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)