UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8TDMboc7loZJcJcVAN5lzCi9vydfT1FHDGny46Rpj8='
WHERE
key_id = '275e5edf12c92f3af50d3b6be2cee09a98e430376747e738e0f44ec50778ffa5'
AND (
token = 'J8TDMboc7loZJcJcVAN5lzCi9vydfT1FHDGny46Rpj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)