UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jkEYvA4aLpyzVsSyUkKrxusm1hfOpGdcjjP6/A+sryk='
WHERE
key_id = '3049038e68664621e2fac01d04305880a7b1d8dbcafa60c7d536c03cc5fb02d3'
AND (
token = 'jkEYvA4aLpyzVsSyUkKrxusm1hfOpGdcjjP6/A+sryk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)