UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0dUWxE7eQaUy1IexWJKc9xcd8mzyAGxvtACNCEOlU54='
WHERE
key_id = 'f04dc75a1afb0c684b28d0c0dd1640d223bd003263b6dd98a9a20a1dae7b3852'
AND (
token = '0dUWxE7eQaUy1IexWJKc9xcd8mzyAGxvtACNCEOlU54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)