UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TaJW8IYt3CG8rNhL8/FDVGc+bNarT9RDUUAJFG7zvg='
WHERE
key_id = 'd9a1a9cd3d7b4c2e200b1acfe1090f9dd901728ea567e112d8a839ee3880b29e'
AND (
token = '6TaJW8IYt3CG8rNhL8/FDVGc+bNarT9RDUUAJFG7zvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)