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