UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dYsJ1l3iMIk6QlbTyW+nSgUBS7GSCcT93c08u5xoqgk='
WHERE
key_id = 'e8252ffe2faad0f953433cc0ab2ff103954bb29f25cb9df87864674152ecedab'
AND (
token = 'dYsJ1l3iMIk6QlbTyW+nSgUBS7GSCcT93c08u5xoqgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)