UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CQhf0lZDlDo6ZAgdVr10m9MLu9sy2XlKoZsPRpsv88c='
WHERE
key_id = '9a8400f74b443fccffe523e6e989acf37ee765806600bbcd5e190b8fd411411d'
AND (
token = 'CQhf0lZDlDo6ZAgdVr10m9MLu9sy2XlKoZsPRpsv88c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)