UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CjE2EVmLqnZmlfouaiwuDpzJFnwAayNovF8NVPs/fyU='
WHERE
key_id = '4f33341cf1f64a33f97195614e33904b41ea969f15827b35cb42d63981f5ac05'
AND (
token = 'CjE2EVmLqnZmlfouaiwuDpzJFnwAayNovF8NVPs/fyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)