UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '88aSpGz32Muj28svpaKoLOVKK8Vo7OF8DaxXRT/Xf4M='
WHERE
key_id = '48b5073ba93926817b7828477434d45fe6e269a31c5b1b83346980de5773ca04'
AND (
token = '88aSpGz32Muj28svpaKoLOVKK8Vo7OF8DaxXRT/Xf4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)