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