UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tgz1rVl9SJAsujo6DmTam3v4QWPfL/IJoX7QOOma8H0='
WHERE
key_id = '1ad0b7d1402956f685ae526bb6680a17322a4e34faab1f08c7a23852ee264d08'
AND (
token = 'tgz1rVl9SJAsujo6DmTam3v4QWPfL/IJoX7QOOma8H0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)