UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zZuJYrECWZopsPL9/nqctRi9gpOYEvMkLlSIxmPdfQ='
WHERE
key_id = '89c29f10405643fec83e4868eca115b78c26316900d4c2a52ddcffc01c246a1c'
AND (
token = '/zZuJYrECWZopsPL9/nqctRi9gpOYEvMkLlSIxmPdfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)