UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgR2sZJ78qH8E00DFm/J7PwByyow0H6CFHC/1YvQLcw='
WHERE
key_id = '8ed9325481e0b267b16eefa3b9a36bcc16ce0aba7bd5d1af887503b3d7eee59e'
AND (
token = 'qgR2sZJ78qH8E00DFm/J7PwByyow0H6CFHC/1YvQLcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)