UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p41D/qPAdF01RHQJq+ICSj+kcR6ttSU/1XbAhIkitgw='
WHERE
key_id = 'a0e41a0e27c0e2ea8afdcf6ea86c485db3a00730e5012059e47dbaa0ab4e750d'
AND (
token = 'p41D/qPAdF01RHQJq+ICSj+kcR6ttSU/1XbAhIkitgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)