UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lx0COJDleXFwU34/srL6zJOB49LiUA2CV6DzHREJ9bM='
WHERE
key_id = '7e7bc80f546de9051b40cdfe98edef19c3f40ab9b1abfa77fd87b18b5f2ca599'
AND (
token = 'lx0COJDleXFwU34/srL6zJOB49LiUA2CV6DzHREJ9bM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)