UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oP8G3md1U1grMwPkXNYZDPxuugIdjg4uzrQCuEHEq1o='
WHERE
key_id = 'ff4fff0d5990410553a4c04725b41fe27376b636af332706d9fd91e966f00c67'
AND (
token = 'oP8G3md1U1grMwPkXNYZDPxuugIdjg4uzrQCuEHEq1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)